Background

The goal of the project is to showcase in a clear and elegant manner some findings from the Yext DataHub that are relevant for the clients of Rankings.io. This is useful and provides added value because the Yext DataHub is buggy, not easy to understand, and not focused on legal services. We requested a data extraction to Yext: all data about legal services in USA.

legal services

Data from : .

Link to a “data dictionary”: https://help.yext.com/hc/en-us/articles/360000001103-Available-metrics

Data Preview

Listings_Overview_Bar_YOY

This dataset corresponds to the left column of the “Metrics Overview” tab.

  • large effect of COVID on Google driving directions and Maps views.
  • same for Direct Queries. Start of the business again?
  • recent increase of Extended Network Clicks. ?

It seems that we don’t have the data from the right column of the “Metrics Overview” tab: Pages Metrics YoY…

Longtail Impressions and Clicks - Search Network Clicks by Type

This data is in the tab “Search Network Listings Clicks” with a title of “Search Network Clicks by Type”.

% Difference in Avg. Longtail Impressions Per Loc - YoY:

Longtail Impressions Per Loc - by month:

% Difference in Avg. Longtail Clicks Per Loc - YoY:

Longtail Clicks Per Loc - by month:

Google My Business Clicks by Type

These are the data from the tab “Google Listings Clicks”.

They are separated in several tables:

  • G_DDs_YOY
  • G_DDs
  • G_PCs_YOY
  • …

Google Phone Calls Per Loc:

Google Website Clicks Per Loc:

Google Driving Directions Per Loc:

Google my Business Impressions - Google Listings Impressions

Data from the tab “Google Listings Impressions”.

Datasets: G_MVs_YOY and G_MVs.

Google Maps Views:

Google Search Views:

Google Listings Queries - Google My Business Queries

Data from the tab “Google Listings Queries / Google My Business Queries”: Google Discovery Queries, Google Direct Queries, Google Branded Queries.

We did not receive these data from Yext…

Google Search CTR

Data from the tab “Google Search CTR / Google Search Console CTR”.

We did not receive these data from Yext…

Page Views & Onpage CTR

Data from the tab “Page Views & Onpage CTR / Page Views & Onpage CTR”.

We did not receive these data from Yext…